AH... ok.. this works now.. i placed UpDate as the new Column name and of
course that did not work either
I looked at the list of reserved names and guess what? :)
update is reserved also.. i changed it to OPDate and it worked fine.
What a PITA!!!!
Thanks everyone for the help. I printed out the list of reserved names in
20point type and hung it on my wall. :)
At 06:24 PM 11/27/00 -0500, you wrote:
>Um .. what what is the datatype of your date field? Change it to timestamp
>if it isn't already, or do a
>
>DateFormat(#Now()#, "whatever") on your date instead of just dumping Now()
>in there. Sybase stores dates as yyyy-mm-dd so see what Access stores them
>as and just format Now() accordingly.
>
>Todd Ashworth
>
>----- Original Message -----
>From: "Chad Gray" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Monday, November 27, 2000 5:18 PM
>Subject: Re: INSERT into error....
>
>
> > --=====================_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_REQUI
>RED,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/[email protected]/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> >
>
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
