--=====================_2669739==_.ALT
Content-Type: text/plain; charset="us-ascii"; format=flowed
ok.. after hacking the SQL insert statement to bits until i just had one
column being inserted i got this error:
Im not sure what it means.... The "login" and "JobInfo" tables do have a
relationship, but not with the column JobNum.
Error Occurred While Processing Request
Error Diagnostic InformationODBC Error Code = 23000 (Integrity constraint
violation)
[Microsoft][ODBC Microsoft Access Driver] You cannot add or change a record
because a related record is required in table 'login'.
SQL = "INSERT INTO JobInfo(JobNum) VALUES( 6732 )"
Data Source = "CJM.mdb" The error occurred while processing an element with
a general identifier of (CFQUERY), occupying document position (76:1) to
(76:60) in the template file
D:\Web\Capitol1interface\chad\uploadaction.cfm.Date/Time: 11/27/00 17:37:32
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)
Remote Address: 209.115.116.102
HTTP Referer: http://209.115.116.151/chad/upload.cfm?name=chad
--=====================_2669739==_.ALT
Content-Type: text/html; charset="us-ascii"
<html>
ok.. after hacking the SQL insert statement to bits until i just had one
column being inserted i got this error:<br>
<br>
Im not sure what it means.... The "login" and
"JobInfo" tables do have a relationship, but not with the
column JobNum.<br>
<br>
<br>
<br>
<br>
<br>
<font size=4><b>Error Occurred While Processing Request<br>
</font>Error Diagnostic Information</b>ODBC Error Code = 23000 (Integrity
constraint violation) <br>
[Microsoft][ODBC Microsoft Access Driver] You cannot add or change a
record because a related record is required in table 'login'. <br>
<br>
SQL = "INSERT INTO JobInfo(JobNum) VALUES( 6732 )" <br>
<br>
Data Source = "CJM.mdb" The error occurred while processing an
element with a general identifier of (CFQUERY), occupying document
position (76:1) to (76:60) in the template file
D:\Web\Capitol1interface\chad\uploadaction.cfm.Date/Time: 11/27/00
17:37:32<br>
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)<br>
Remote Address: 209.115.116.102<br>
<table border=1>
<tr><td width=624>HTTP Referer:
<a href="http://209.115.116.151/chad/upload.cfm?name=chad"
eudora="autourl">http://209.115.116.151/chad/upload.cfm?name=chad</a></td></tr>
</table>
<br>
</html>
--=====================_2669739==_.ALT--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
