Solved

Error message executing a sql statement in an ASP page

Posted on 2007-03-25
11
208 Views
Last Modified: 2010-03-20
I am receiving the following error on my asp page.

Microsoft OLE DB Provider for SQL Server error '80040e14'

Incorrect syntax near ','.

/doUpload.asp, line 102

On line 102, it is trying to execute the following sql statement:

INSERT INTO FacilitySource VALUES ('3/4/2007 15:00','RIT-00107','RIT AID CORPORATION','107','','FS',3,4396,'',4396,'Preventive Maintenance','PARKINGLOTSWEEPINGMAINTPM','PARKING LOT SWEEPING PM','RIT-00107 - PARKING LOT SWEEPING PM - 1X/WK','REISINGER, JENNIFER','PS','PM-10009','INPRG','In Progress (INPRG)','43',,8490,'GENESIS','GENESIS','0','NO','','NO','43','43','1/18/2007','NO','','654 COLVIN AVENUE','KENMORE','NY',14217-2825,'716-447-9128','No','No','','','','');

Any help on fixing this problem is greatly appreciated.

Thanks
0
Comment
Question by:sigkappu
  • 5
  • 3
  • 2
  • +1
11 Comments
 
LVL 51

Expert Comment

by:Ryan Chong
ID: 18788228
>>'43',,8490,

some value is missing here, try check your scripting to rectify this...
0
 

Assisted Solution

by:Gadik
Gadik earned 20 total points
ID: 18788240
The following value is not correct - it is not a number, so it should be in single quotation marks:

14217-2825
0
 

Author Comment

by:sigkappu
ID: 18788280
'43',,8490, Is just a blank field on creation it gets updated at a later date to contain a value
I changed 14217-2825  to 14217 and I still get the same error.

Any other of ideas of what it might be?  I'm at  a loss.
0
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 

Expert Comment

by:Gadik
ID: 18788293
Is the first field of your table defined as character or date/time? Probably the date should be formatted...
0
 
LVL 51

Expert Comment

by:Ryan Chong
ID: 18788295
try change '43',,8490 to '43','',8490 and change 14217-2825 to '14217-2825' ?

like:

INSERT INTO FacilitySource VALUES ('3/4/2007 15:00','RIT-00107','RIT AID CORPORATION','107','','FS',3,4396,'',4396,'Preventive Maintenance','PARKINGLOTSWEEPINGMAINTPM','PARKING LOT SWEEPING PM','RIT-00107 - PARKING LOT SWEEPING PM - 1X/WK','REISINGER, JENNIFER','PS','PM-10009','INPRG','In Progress (INPRG)','43','',8490,'GENESIS','GENESIS','0','NO','','NO','43','43','1/18/2007','NO','','654 COLVIN AVENUE','KENMORE','NY','14217-2825','716-447-9128','No','No','','','','');
0
 

Author Comment

by:sigkappu
ID: 18788313
The first field is defined as date/time.  What formatting do I need to do to it?
0
 
LVL 51

Accepted Solution

by:
Ryan Chong earned 480 total points
ID: 18788338
Your first error of:

Incorrect syntax near ','.

is definitely that you got a missing value in your SQL statement.


If your first field is a date/time data type, you can try use date format of mm/dd/yyyy, or other formats like: yyyy/mm/dd or dd mmm yyyy, etc
0
 

Author Comment

by:sigkappu
ID: 18788425
For the field I want to be empty when it inserts, it is a numeric field.  What can I put into the SQL statement to put an empty field in?  If it were a text field I would put '', but I don't know what to put for a numberic field.
0
 
LVL 51

Expert Comment

by:Ryan Chong
ID: 18788464
>>What can I put into the SQL statement to put an empty field in?  If it were a text field I would put '', but I don't know what to put for a numberic field.

try put a 0 (zero) or if it allows NULL, you can try put NULL on that field.

or else, explicitly describe what fields you want to insert with values in your Insert SQL statement, like:

Insert into yourTable (field1, field2, fieldN ) values ('value1' , 12345, '3/25/2007');
0
 
LVL 51

Assisted Solution

by:Ryan Chong
Ryan Chong earned 480 total points
ID: 18788482
in your case:

INSERT INTO FacilitySource (field1, field2, fieldN... ) VALUES ('3/4/2007 15:00','RIT-00107','Other Fields value...' );

get the idea?
0
 
LVL 2

Expert Comment

by:bandolex2
ID: 18791099
provide a 0 for numeric fields that you want empty.
band.
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In database programming, custom sort order seems to be necessary quite often, at least in my experience and time here at EE. Within the realm of custom sorting is the sorting of numbers and text independently (i.e., treating the numbers as number…
I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:   The Exchange of informatio…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question