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
