Click here to Skip to main content
15,889,096 members
Home / Discussions / Web Development
   

Web Development

 
QuestionRe: Data Grid Selection issue Pin
Tauseef A13-Jun-07 21:05
Tauseef A13-Jun-07 21:05 
AnswerRe: Data Grid Selection issue Pin
_AK_13-Jun-07 21:11
_AK_13-Jun-07 21:11 
QuestionRe: Data Grid Selection issue Pin
Tauseef A13-Jun-07 21:37
Tauseef A13-Jun-07 21:37 
AnswerRe: Data Grid Selection issue Pin
_AK_13-Jun-07 22:01
_AK_13-Jun-07 22:01 
QuestionRe: Data Grid Selection issue Pin
Tauseef A13-Jun-07 23:23
Tauseef A13-Jun-07 23:23 
QuestionProblem with Active Pin
Socheat.Net13-Jun-07 16:24
Socheat.Net13-Jun-07 16:24 
AnswerRe: Problem with Active Pin
Johnny ²13-Jun-07 17:42
Johnny ²13-Jun-07 17:42 
QuestionReading an excel file using ASP Pin
acerunner31613-Jun-07 16:08
acerunner31613-Jun-07 16:08 
<br />
dim xlsConn, xlsRS<br />
set xlsConn = Server.CreateObject("ADODB.connection")<br />
xlsConn.Open "Driver={Microsoft Excel Driver (*.xls)}; DBQ=" & uploadsDirVar & "\" & fileName<br />
<br />
set xlsRS = Server.CreateObject("ADODB.recordset")<br />
xlsRS.open "SELECT SerNumber,IO2,ICO,IH2,I1,I2,KA,R FROM AddCalData", xlsConn<br />
<br />
xlsarr = xlsRS.GetRows()<br />


The problem is that the excel file has some fields that are optional. If the some of the fields in the first data line are empty, then the remaining data in that column is lost. All data are numbers. I think it has something to do with formatting. Maybe the drivers need data in the first column to determine datatype. I found somewhere that putting IMEX=1 in the connection string will make it not restrict datatype. I did not work.

If the first column has all fields filled in, then the remaining data is fine. Please help. Thanks in advance!
Questionevent location Pin
Ali Tavakol13-Jun-07 5:45
Ali Tavakol13-Jun-07 5:45 
QuestionScroll Problem in Div Pin
Panchal Hardik13-Jun-07 2:34
Panchal Hardik13-Jun-07 2:34 
QuestionMembership fees Pin
john3413-Jun-07 2:30
john3413-Jun-07 2:30 
AnswerRe: Membership fees Pin
Johnny ²13-Jun-07 3:13
Johnny ²13-Jun-07 3:13 
GeneralRe: Membership fees Pin
badgrs13-Jun-07 3:19
badgrs13-Jun-07 3:19 
AnswerRe: Membership fees Pin
badgrs13-Jun-07 3:18
badgrs13-Jun-07 3:18 
GeneralRe: Membership fees Pin
intonet14-Jun-07 6:16
intonet14-Jun-07 6:16 
AnswerRe: Membership fees Pin
john3413-Jun-07 21:36
john3413-Jun-07 21:36 
QuestionRe: Membership fees Pin
Tauseef A13-Jun-07 21:53
Tauseef A13-Jun-07 21:53 
AnswerRe: Membership fees Pin
john3413-Jun-07 22:31
john3413-Jun-07 22:31 
QuestionAJAX using DIV throws a runtime error Pin
ajisthekingofpop12-Jun-07 22:59
ajisthekingofpop12-Jun-07 22:59 
AnswerRe: AJAX using DIV throws a runtime error Pin
badgrs13-Jun-07 1:27
badgrs13-Jun-07 1:27 
GeneralRe: AJAX using DIV throws a runtime error Pin
ajisthekingofpop13-Jun-07 11:25
ajisthekingofpop13-Jun-07 11:25 
GeneralRe: AJAX using DIV throws a runtime error Pin
ajisthekingofpop13-Jun-07 11:27
ajisthekingofpop13-Jun-07 11:27 
AnswerRe: AJAX using DIV throws a runtime error Pin
bartedgerton15-Jun-07 9:37
bartedgerton15-Jun-07 9:37 
QuestionData Grid ISsue Pin
Tauseef A12-Jun-07 21:55
Tauseef A12-Jun-07 21:55 
AnswerRe: Data Grid ISsue Pin
PrakashBhaskar13-Jun-07 2:49
PrakashBhaskar13-Jun-07 2:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.