insert failed

[wargk]

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??

[pukkel]

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