Professional Web Applications Themes

insert failed - Coldfusion - Getting Started

hope you can help solve this problem, ok my database field: tblA TSK_ID (autonumber) key (not Null) USR_ID (autonumber) (not Null) TSKCTDT (datetime) tblB USR_ID (autonumber) key (not Null) USRName (varchar) USRLogin (varchar) USRPassword (varchar) USR_ID = relationship tblA + tblB __________________________________________________ ___________ my form: <form name="form" action="ActLogin.cfm" method="post" onSubmit="return validate();"> <input type="hidden" name="TSKCTDT" value="<cfoutput>#DateFormat(now(), 'mm/dd/yyyy')#</cfoutput>"> <input type="hidden" name="USR_ID" value="#USR_ID#"> <input type="text" name="USRName" value=""> User Name<br> <input type="text" name="USRLoginID" value=""> User ID<br> <input type="password" name="USRPassword" value=""> Password<br> <input type="submit" name="Submit" value="Submit"> </form> __________________________________________________ ____________ my ActLogin <CFQUERY NAME="qITD1" DATASOURCE="ITDTask"> INSERT INTO dbo.A (USR_ID, TSKCTDT) VALUES ('#form.USR_ID#', '#form.TSKCTDT#' ) ; </CFQUERY> ...

  1. #1

    Default insert failed

    hope you can help solve this problem,

    ok my database field:

    tblA
    TSK_ID (autonumber) key (not Null)
    USR_ID (autonumber) (not Null)
    TSKCTDT (datetime)

    tblB
    USR_ID (autonumber) key (not Null)
    USRName (varchar)
    USRLogin (varchar)
    USRPassword (varchar)

    USR_ID = relationship tblA + tblB
    __________________________________________________ ___________


    my form:
    <form name="form" action="ActLogin.cfm" method="post" onSubmit="return
    validate();">
    <input type="hidden" name="TSKCTDT" value="<cfoutput>#DateFormat(now(),
    'mm/dd/yyyy')#</cfoutput>">
    <input type="hidden" name="USR_ID" value="#USR_ID#">
    <input type="text" name="USRName" value=""> User Name<br>
    <input type="text" name="USRLoginID" value=""> User ID<br>
    <input type="password" name="USRPassword" value=""> Password<br>
    <input type="submit" name="Submit" value="Submit">

    </form>
    __________________________________________________ ____________

    my ActLogin

    <CFQUERY NAME="qITD1" DATASOURCE="ITDTask">
    INSERT INTO dbo.A (USR_ID, TSKCTDT)
    VALUES ('#form.USR_ID#', '#form.TSKCTDT#' ) ;
    </CFQUERY>

    <CFQUERY NAME="qITD2" DATASOURCE="ITDTask">
    INSERT INTO dbo.B User (USRName, USRLoginID, USRPassword)
    VALUES ('#form.USRName#', '#form.USRLoginID#', '#form.USRPassword#' ) ;
    </CFQUERY>
    __________________________________________________ _______________

    so when i submit form then the message:


    Macromedia][SQLServer JDBC Driver][SQLServer]Syntax error converting the
    varchar value '#USR_ID#' to a column of data type
    int.

    The Error Occurred in C:\Inetpub\wwwroot\ITDTask\ActLogin.cfm: line 15

    13 : INSERT INTO dbo.tTSK_ITD (USR_ID, TSKCTDT)
    14 : VALUES ('#form.USR_ID#', '#form.TSKCTDT#' ) ;
    15 : </CFQUERY>
    16 :
    17 : <CFQUERY NAME="qITD2" DATASOURCE="ITDTask">
    SQL INSERT INTO dbo.tTSK_ITD (USR_ID, TSKCTDT) VALUES ('#USR_ID#',
    '04/08/2005' )



    why??

    wargk Guest

  2. #2

    Default Re: insert failed

    Because you forgot to put the #USR_ID# in your form between cfoutput tags!
    pukkel Guest

Similar Threads

  1. Question Insert from ASP to SQL using recordset data as values in insert statement
    By JasonM in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: June 13th, 05:54 PM
  2. serial increments on failed insert
    By David Kammer in forum PostgreSQL / PGSQL
    Replies: 7
    Last Post: March 10th, 03:27 PM
  3. What's faster - loop for insert or insert...select.
    By mr. modus in forum Coldfusion Database Access
    Replies: 2
    Last Post: December 10th, 01:57 AM
  4. Replies: 0
    Last Post: May 13th, 04:40 AM
  5. Replies: 3
    Last Post: September 30th, 09:24 PM

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