Update values without Page Refresh

[m1post]

Hi,

I'm very much a novice, and wondered if someone could help. I'll try to be as specific as possible, but don't waant you to have to read too much.

I have 2 pages in the sequence. 1st allows customers to login, passing control to the 2nd, which on entry returns their balance details from my DB (using their Reference 'BookingRef = Request.form("txtBookingRef")') and displays an additional section allowing them to enter an amount of a part payment, which supsequently passes them to my PayPal account (Form2).

The main purpose is that on the 2nd page, a value is entered, the update button clicked, other values on the page are updated, i.e.
Enter Amount (Input field)
- update button -
'Amount Entered' asp calculated field
'CC Charge' asp calculated field
'Total Amount' asp calculated field
I have both pages working ok (individually, i.e. hardcoding the BookingRef on the 2nd page), but when I pass it from page 1 and when I click the update button after entering a value, the complete page is refreshed, and the Reference is lost, with the page returning the following error 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1' + referring to the line number of my 'rs.Open sqlStr, conn'.

1. I would prefer to keep it in asp. Is there any way I can retain my BookingRef passed from page 1 when I update the other values?

2. I have changed Page2 & tried javascript, using onChange, which works ok, but I can't work out how to get the 'Total Amount' value to my Hidden PayPal form also ( I can get it to the 'Total Amount' ok - as it is in the same form)

I would really appreciate any suggestions for #1

If #1 is not possible, can you help with #2

thanks, Michael

PS - I should have mentioned, that I am NOT posting the amount entered back to the DB - I do that manually myself via different pages, as I need to allocate it differently.

[jhardman]

1- To keep data with a user through multiple pages, I prefer to use session-level variables

if request.form("txtBookingRef") <> "" then
   session("BookingRef") = Request.form("txtBookingRef")
end if

this can then be accessed on every page the user visits.

2- This is kind of a javascript issue. I'm not an expert in javascript but I could probably get it to work. I would need to see your code though.

Let me know if this helps.

Jared

[m1post]

Thanks Jared,
I'll stick with the asp option if I can get it to work.
Here's the code I'm using to get the details back from the DB
----------------
BookingRef = Request.form("txtBookingRef")
sqlStr = " SELECT td.task_detail_id_int"
sqlStr = sqlStr & " FROM task_detail td"
sqlStr = sqlStr & " JOIN booking b ON td.booking_id_int = b.booking_id_int"
sqlStr = sqlStr & " WHERE status_id_int = 1 and b.booking_ref_vch = " + cstr(BookingRef)

conn.Open
rs.Open sqlStr, conn
TaskID = rs("task_detail_id_int")
conn.Close
---------------
I then use the TaskID to pull back all the client, payment, Booking Status, etc. from an include file.

where should I insert the session-level code?

Thanks again, Michael

[markrawlingson]

If BookingRef is what you want to be able to access from any page, then you would insert it like so...

Session("BookingRef") = Request.form("txtBookingRef")
sqlStr = " SELECT td.task_detail_id_int"
sqlStr = sqlStr & " FROM task_detail td"
sqlStr = sqlStr & " JOIN booking b ON td.booking_id_int = b.booking_id_int"
sqlStr = sqlStr & " WHERE status_id_int = 1 and b.booking_ref_vch = " + cstr(Session("BookingRef"))
 
conn.Open 
rs.Open sqlStr, conn
TaskID = rs("task_detail_id_int")
conn.Close
 

Instead of storing the information from Request.Form("txtBookingRef") in a variable which can only be used within this script, you set it into a Session variable named Session("BookingRef") which is stored in the server's memory, and thus can be accessed again on any page simply by referring to it...

Response.Write "Your bookingref = " & Session("BookingRef")
 

[m1post]

Thanks Mark.

I've tried all variations, but still can't get it to hold the BookingRef in the session.
Error message below - I'm using a MySQL DB, so not sure if that makes any difference?
---------------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[MySQL][ODBC 3.51 Driver][mysqld-5.0.27-standard-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''
------------------------------------
I only get this error message when I attempt to update the details on the page. When I load it first, I can get all details back from the DB ok.

hope you can help.

thanks, Michael

[m1post]

It's the update <form> that seems to be causing the problem.
If I just referesh the page - fine.
If I click the Update button (within the <form>) I get the above error, so I am loosing the "BookingRef" at that stage.

(the update <form> takes the Payment Amount Entered, updates/displays the Payment Amount Entered (to a seperate field), Updates/displays the Credit Card Charge & the Total Amount to be charged.

But the <form> does not actually use/hold the BookingRef.

Thanks, Michael

[markrawlingson]

Hi Michael,

Show the update statement.

[m1post]

Hi Chris,

I've stripped all the other details out, except the Update <form>. which works ok in itself, but I get the above error when I try the update with all the other details, i.e. the BookingRef, etc from the previous page & DB.

Thanks, Michael

<html>
    <head>
    <script language="javascript">            
            function ValidateForm()
            {
                var rtnStr = "";
                var vCtrl = "";
 
            if(document.frmUpdatePartPayform.AmountEntered.value == "")
                {
                    rtnStr = rtnStr + " - Please enter Payment Amount.\n"
                    if (vCtrl == "")
                    {
                        vCtrl = "AmountEntered";
                    }
                }
 
            if ((document.frmUpdatePartPayform.AmountEntered.value.length > 0) && (isNaN(document.frmUpdatePartPayform.AmountEntered.value*(-1)*(-1))))
                {
                    rtnStr = rtnStr + " - Please enter a numeric Payment Value.\n"
                    if (vCtrl == "")
                    {
                        vCtrl = "AmountEntered";
                    }
                }
            if (rtnStr != "")
                {
                    alert(rtnStr)
                    document.getElementById(vCtrl).focus()
                    return false;        
                }
                else
                {
                    return true;
                }
            }    
</script>
<%
cc_percent_charge = 0.035
AmountEntered = Request.Form("AmountEntered")
 
    If AmountEntered = "" then CC_Charge = FormatNumber((0),2)
    If AmountEntered = "" then Display_CC_Charge = FormatNumber((0),2)
    If AmountEntered = "" then Display_AmountEntered = FormatNumber((0),2)
    If AmountEntered <> "" then CC_Charge = (AmountEntered * cc_percent_charge)
    If AmountEntered <> "" then Display_CC_Charge = FormatNumber((CC_Charge),2)
    If AmountEntered <> "" then Display_AmountEntered = FormatNumber((AmountEntered),2)
 
    TotalToPay = (AmountEntered + CC_Charge)
    Display_TotalToPay = FormatNumber((TotalToPay),2)
%>
        <table>    
        <form name="frmUpdatePartPayform" method="post"  onsubmit="return ValidateForm();" ID="Form1">
            <tr>
                <td NOWRAP>
                    Enter the Payment Amount
                </td>
                <td >
                    <input size="4" name="AmountEntered">
                </td>
            </tr>
            <tr >
                <td NOWRAP >
                    <input valign="middle" class="button"  type="submit" value="Click Here To Update">
                </td>
            </tr>
            <tr>
                <td NOWRAP >
                    <b>Amount Entered</b>
                </td>
                <td>
                    <b><%=Display_AmountEntered%></b>
                </td>
            </tr>
            <tr>
                <td NOWRAP>
                    <b>Processing Charge </b>
                </td>
                <td >
                    <%=Display_CC_Charge%>
                </td>
            </tr>
            <tr>
                <td NOWRAP>
                    <b>Total to Pay on this Transaction</b>
                </td>
                <td >
                    <b><%=Display_TotalToPay%></b>
                </td>
            </tr>
        </form>    
        </table>
    </body>
</html>
 
 

[m1post]

Sorry Mark,

I realised I hadn't included the 2nd <form> that is (needed to be) updated to go out to my PayPal account

Thanks, Michael

<form action="https://www.paypal.com/cgi-bin/webscr" method="post" ID="Form2">
    <input type="hidden" name="amount" value="<%=Display_TotalToPay%>" ID="Hidden16">
    <input class="button" type="submit" name="submit" value="Proceed to Payment" ID="Submit2">
</form>