Error message executing a sql statement in an ASP page

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
sigkappuAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ryan ChongCommented:
>>'43',,8490,

some value is missing here, try check your scripting to rectify this...
0
GadikCommented:
The following value is not correct - it is not a number, so it should be in single quotation marks:

14217-2825
0
sigkappuAuthor Commented:
'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
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

GadikCommented:
Is the first field of your table defined as character or date/time? Probably the date should be formatted...
0
Ryan ChongCommented:
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
sigkappuAuthor Commented:
The first field is defined as date/time.  What formatting do I need to do to it?
0
Ryan ChongCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sigkappuAuthor Commented:
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
Ryan ChongCommented:
>>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
Ryan ChongCommented:
in your case:

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

get the idea?
0
bandolex2Commented:
provide a 0 for numeric fields that you want empty.
band.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Query Syntax

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.