Professional Web Applications Themes

Passing default value from Form - Coldfusion - Getting Started

I'm trying to pass a default value from a hidden tag on a form, but I'm not sure it's possible. Here's the scenario: I want to set a default value of "pending" for a ticket status (which is changed at a later date), but when I use the hidden input tag, I get a data mismatch error. Code: Form page: <input type="hidden" value="Pending" name="ticketstatus"> Insert page: <CFQUERY NAME="InsertRequest" DATASOURCE="service"> INSERT INTO service (company, ticketstatus) VALUES ('#Form.company#' , '#Form.ticketstatus#') </CFQUERY> Suggestions? Thanks, Dale...

  1. #1

    Default Passing default value from Form

    I'm trying to pass a default value from a hidden tag on a form, but I'm not
    sure it's possible. Here's the scenario:

    I want to set a default value of "pending" for a ticket status (which is
    changed at a later date), but when I use the hidden input tag, I get a data
    mismatch error. Code:

    Form page:

    <input type="hidden" value="Pending" name="ticketstatus">

    Insert page:

    <CFQUERY NAME="InsertRequest" DATASOURCE="service">
    INSERT INTO service
    (company, ticketstatus)

    VALUES
    ('#Form.company#' ,
    '#Form.ticketstatus#')
    </CFQUERY>

    Suggestions?

    Thanks,
    Dale

    dzjc01 Guest

  2. #2

    Default Re: Passing default value from Form

    Is the data type of the ticketstatus column alpha-nuemric or just numeric?
    TA-Selene Guest

  3. #3

    Default Re: Passing default value from Form

    Got it fixed. Had a typo on the form.

    Thanks
    dzjc01 Guest

Similar Threads

  1. default value for form data
    By sdtke212 in forum Coldfusion Database Access
    Replies: 3
    Last Post: November 7th, 03:07 AM
  2. passing password from form to form
    By Hi Ho in forum PHP Development
    Replies: 1
    Last Post: February 5th, 01:03 AM
  3. Set button as default on web form
    By Patrick Steele [MVP] in forum ASP.NET General
    Replies: 1
    Last Post: July 14th, 09:03 PM
  4. #24570 [NEW]: Passing objects as default function parameters
    By da_bomb at hisplace dot net in forum PHP Development
    Replies: 0
    Last Post: July 9th, 11:06 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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139