--=====================_1574282==_.ALT
Content-Type: text/plain; charset="us-ascii"; format=flowed
At 05:09 PM 11/27/00 -0500, you wrote:
>Is the "date" field name a reserved word? Try changing that to something
>besides date.
>
>What is the full error message?
Here is the entire error message with most of the debugging records. I
tried changing the column name to UpDate instead of Date.
Thanks for the fast replies :)
Queries
maxjobnum (Records=1, Time=10ms)
SQL =
SELECT Max(JOBNUM) as NEWJOBNUM
FROM JOBINFO
getuploaddir (Records=1, Time=10ms)
SQL =
Select name, upload, customerID, loginID
from login
where 'chad' = login.name
customerlist (Records=1, Time=10ms)
SQL =
SELECT *
FROM CUSTOMERDATA
WHERE CUSTOMERID = 35
addjob (Records=0, Time=10ms)
SQL =
INSERT INTO JOBINFO(JOBNUM, CUSTOMERID, COMPANYNAME,
)
VALUES ( 6726
,35, 'CAPITAL ONE',
)
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC
Microsoft Access Driver]
Syntax error in INSERT INTO statement. SQL = "INSERT INTO
JobInfo(JobNum,LoginID,UpDate,FileName)
VALUES( 6727, 1, {ts '2000-11-27 17:20:37'},'calendar2.PDF' )"
Data Source = "CJM.mdb" The error occurred while processing an element with
a general identifier of (CFQUERY), occupying document position (84:1) to
(84:60) in the template file
D:\Web\Capitol1interface\chad\uploadaction.cfm.Date/Time: 11/27/00 17:20:37
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
Execution Time
201 milliseconds
Parameters
Form Fields:
[EMAIL PROTECTED]
CSR_REQUIRED=You need to Select your CSR email.
CUSTOMER=chad
CUSTOMER_REQUIRED=You need to Enter your Customer Name.
DATE=Nov 27 5:13 PM
[EMAIL PROTECTED]
EMAIL_REQUIRED=You need to Enter your Customer email.
FIELDNAMES=NAME,FILENAME_REQUIRED,CUSTOMER_REQUIRED,EMAIL_REQUIRED,CSR_REQUI
RED,DATE,FILENAME,CUSTOMER,EMAIL,CSR
FILENAME=C:\WINNT\ACF2E.tmp
FILENAME_REQUIRED=You need to Select A File To Upload.
NAME=chad
--=====================_1574282==_.ALT
Content-Type: text/html; charset="us-ascii"
<html>
At 05:09 PM 11/27/00 -0500, you wrote:<br>
<blockquote type=cite cite>Is the "date" field name a reserved
word? Try changing that to something<br>
besides date.<br>
<br>
What is the full error message?</blockquote><br>
Here is the entire error message with most of the debugging
records. I tried changing the column name to UpDate instead of
Date.<br>
<br>
Thanks for the fast replies :)<br>
<br>
<br>
<br>
<br>
<b>Queries</b> <br>
<div align="center">
<br>
<br>
<font face="Courier New, Courier"><b></div>
maxjobnum</b> (Records=1, Time=10ms)<br>
SQL = <br>
SELECT Max(JOBNUM) as NEWJOBNUM<br>
FROM JOBINFO<br>
<br>
<b>getuploaddir</b> (Records=1, Time=10ms)<br>
SQL = <br>
Select name, upload, customerID, loginID<br>
from login<br>
where 'chad' = login.name<br>
<br>
<b>customerlist</b> (Records=1, Time=10ms)<br>
SQL = <br>
SELECT *<br>
FROM CUSTOMERDATA<br>
WHERE CUSTOMERID = 35<br>
<br>
<b>addjob</b> (Records=0, Time=10ms)<br>
SQL = <br>
INSERT INTO JOBINFO(JOBNUM, CUSTOMERID, COMPANYNAME, <br>
<br>
)<br>
VALUES ( 6726<br>
,35, 'CAPITAL ONE',<br>
)<br>
<br>
</font><font size=4><b>Error Occurred While Processing Request<br>
</font>Error Diagnostic Information<br>
</b>ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] <br>
<br>
Syntax error in INSERT INTO statement. SQL = "INSERT INTO
JobInfo(JobNum,LoginID,UpDate,FileName) <br>
VALUES( 6727, 1, {ts '2000-11-27 17:20:37'},'calendar2.PDF' )"
<br>
<br>
Data Source = "CJM.mdb" The error occurred while processing an
element with a general identifier of (CFQUERY), occupying document
position (84:1) to (84:60) in the template file
D:\Web\Capitol1interface\chad\uploadaction.cfm.Date/Time: 11/27/00
17:20:37<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>
<br>
<font face="Times New Roman, Times" size=2><b>Execution Time <br>
</font><font face="Courier New, Courier">201 milliseconds<br>
<br>
</font><font face="Times New Roman, Times" size=2>Parameters<br>
</font><font face="Courier New, Courier">Form Fields:<br>
<br>
[EMAIL PROTECTED]<br>
CSR_REQUIRED=You need to Select your CSR email.<br>
CUSTOMER=chad<br>
CUSTOMER_REQUIRED=You need to Enter your Customer Name.<br>
DATE=Nov 27 5:13 PM<br>
[EMAIL PROTECTED]<br>
EMAIL_REQUIRED=You need to Enter your Customer email.<br>
FIELDNAMES=NAME,FILENAME_REQUIRED,CUSTOMER_REQUIRED,EMAIL_REQUIRED,CSR_REQUIRED,DATE,FILENAME,CUSTOMER,EMAIL,CSR<br>
FILENAME=C:\WINNT\ACF2E.tmp<br>
FILENAME_REQUIRED=You need to Select A File To Upload.<br>
NAME=chad<br>
</font></b></html>
--=====================_1574282==_.ALT--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists