[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Error message executing a sql statement in an ASP page

Posted on 2007-03-25
11
Medium Priority
?
216 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 2
  • +1
11 Comments
 
LVL 53

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 80 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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 53

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 53

Accepted Solution

by:
Ryan Chong earned 1920 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 53

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 53

Assisted Solution

by:Ryan Chong
Ryan Chong earned 1920 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

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

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

I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

649 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