Enter the SQL code you wish to run in the box below:

CAUTION: This will modify the ACTIVE database which controls the entire web site. DO NOT use this feature unless you are POSITIVE that you know what you are about to do.

The follwing SQL code was written to the database:
#frmSQL.code#.

'#frmSQL.statement#'

Sorry the code did not work.

[allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => d088 [ip] => webforumsuser@m [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 1 [islastshown] => [isfirstshown] => 1 [attachments] => [allattachments] => ) --> Error Passing Form Value - Macromedia ColdFusion

Error Passing Form Value - Macromedia ColdFusion

Can someone please tell me why I'm not getting the form value passed to the action page? <!--SQL.CFM ************************************************** ***************---> <script LANGUAGE="JavaScript"> function confirmSubmit() { var agree=confirm("Are you sure you wish to continue?"); if (agree) return true ; else return false ; } </script> <form action="act_SQL.cfm" method="post" name="frmSQL" id="frmSQL"> <table width="400" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="2"> <p align="center"><span class="blueReg">Enter the SQL code you wish to run in the box below: </span><br> <textarea name="code" cols="50" rows="10" class="sponsor" id="statement"></textarea> <br> <span class="blueBold">CAUTION:</span><span class="blueReg"> This will modify the </span><span class="blueBold">ACTIVE database</span><span class="blueReg"> which controls the entire web site.</span><span class="blueBold"> DO NOT</span><span class="blueReg"> ...

  1. #1

    Default Error Passing Form Value

    Can someone please tell me why I'm not getting the form value passed to the
    action page?



    <!--SQL.CFM
    ************************************************** ***************--->
    <script LANGUAGE="JavaScript">
    function confirmSubmit()
    {
    var agree=confirm("Are you sure you wish to continue?");
    if (agree)
    return true ;
    else
    return false ;
    }
    </script>


    <form action="act_SQL.cfm" method="post" name="frmSQL" id="frmSQL">
    <table width="400" border="0" cellspacing="0" cellpadding="0">
    <tr>
    <td colspan="2">
    <p align="center"><span class="blueReg">Enter the SQL code you wish to
    run in the box below: </span><br>
    <textarea name="code" cols="50" rows="10" class="sponsor"
    id="statement"></textarea>
    <br>
    <span class="blueBold">CAUTION:</span><span class="blueReg"> This
    will modify the </span><span class="blueBold">ACTIVE database</span><span
    class="blueReg"> which controls the entire web site.</span><span
    class="blueBold"> DO NOT</span><span class="blueReg"> use this feature unless
    you are </span><span class="blueBold">POSITIVE</span><span class="blueReg">
    that you know what you are about to do.</span><br>
    <br>
    </p>
    </td>
    </tr>
    <tr>
    <td><input type="submit" name="Submit" value="Run Statement"
    onClick="confirmSubmit()"></td>
    <td><input type="reset" name="Reset" value="Reset"></td>
    </tr>
    </table>
    </form>

    <p>
    <p>

    </center>
    </body>
    </html>





    <!---ACT_SQL.CFM
    ************************************************** ***************--->
    <cfparam name="frmSQL.code" default = "0">

    <cfif frmSQL.code NEQ "0">
    <CFOUTPUT>
    <P>The follwing SQL code was written to the database:<br> #frmSQL.code#.</P>
    </CFOUTPUT>

    <cfquery datasource="#dsn#" name="runSQL">
    '#frmSQL.statement#'
    </cfquery>

    <!--- bring to --->
    <cflocation url="membership/dsp_MemberList.cfm">
    <cfelse>
    <cfoutput><p>Sorry the code did not work.</p></cfoutput>
    </cfif>

    d088 Guest

  2. #2

    Default Re: Error Passing Form Value

    <cfparam name='frmSQL.code' default = '0'>
    <cfif frmSQL.code NEQ '0'>

    -should be-

    <cfparam name='form.code' default = '0'>
    <cfif form.code NEQ '0'>

    tjfrevert Guest

  3. #3

    Default Re: Error Passing Form Value

    Thank You!

    d088 Guest

Similar Threads

  1. Passing A Form Variable
    By drdagwood in forum Coldfusion - Getting Started
    Replies: 3
    Last Post: July 14th, 08:45 PM
  2. passing variables from Form.
    By Thunderbirds in forum Coldfusion - Getting Started
    Replies: 3
    Last Post: February 18th, 02:24 PM
  3. passing password from form to form
    By Hi Ho in forum PHP Development
    Replies: 1
    Last Post: February 5th, 01:03 AM
  4. Replies: 1
    Last Post: September 18th, 06:07 PM
  5. passing arguments from web-form to win-form
    By Mart Rogers in forum ASP.NET Web Services
    Replies: 6
    Last Post: July 9th, 07:18 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •