Solved

Input string was not in a correct format. error

Posted on 2010-09-07
3
728 Views
Last Modified: 2013-11-25
I'm getting this error:

Exception Details: System.FormatException: Input string was not in a correct format.

 vbssript code
The source looks like this <snippet>:

Dim CourseQuery
Dim CourseQuery_numRows
CourseQuery = Server.CreateObject("ADODB.Recordset")
CourseQuery.ActiveConnection = MM_connLearnDirectDB_STRING
CourseQuery.Source = "SELECT course.course_id, " & _
"course.course_name, " & _"course.summary, " & _
"provider.provider_id," & _

Open in new window


I'm converting the page over from asp to aspx , anyone know whats causing it?
0
Comment
Question by:darren-w-
[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
3 Comments
 
LVL 22

Expert Comment

by:Om Prakash
ID: 33618952
0
 
LVL 11

Expert Comment

by:tobzzz
ID: 33619840
Line 6 needs to break into line 7 so this:
"course.course_name, " & _"course.summary, " & _
becomes
"course.course_name, " & _
"course.summary, " & _
0
 
LVL 13

Accepted Solution

by:
darren-w- earned 0 total points
ID: 33625546
Hi,

Tobzz, the snippet was a little wrong, the syntax is correct, I will give up on converting the form over from asp to aspx for now, reverted back to the previous version.

D
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Building JSON Results Table FROM DB 9 48
Hide and Unhide Table 6 42
Post from Jquery mobile form goes wrong in classic asp action page 2 34
Add Rows on a Table 8 48
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

739 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