Error Executing Database Query

[artbondoc]

Hi,

Im new to this forum and coldfusion.  I am getting an error from cf and the error is referencing where it occured.

here is the line # where the error is occuring...

210: <cfset thisCell = #RemoveChars (thisCell, 1, 4) # ?>

211: '#thisCell#',

212: </cfloop>

213: ' '

214: ) ;

Any help from anyone would be very much appreciated.  Thanks.

[ilssac]

What does the error say?

And could it possible be refering to that qustion mark [?] character at the end of line 210 that probably should be a slash [/] character?

[artbondoc]

Hi Ian,

I think this is where is error is happening...

at cfparseData2ecfm999309703$funcINSERTROW.runFunction(E:\inetpub\Wwwroot\me\db8051\parseData.cfm:212) at cfparseData2ecfm999309703.runPage(E:\inetpub\Wwwroot\me\db8051\parseData.cfm:132) at cfparseData2ecfm999309703$funcINSERTROW.runFunction(E:\inetpub\Wwwroot\me\db8051\parseData.cfm:212) at cfparseData2ecfm999309703.runPage(E:\inetpub\Wwwroot\me\db8051\parseData.cfm:132)

Thank.

Art

[ilssac]

But what is the actual error!

[artbondoc]

I got it to work.  The issue was in this line...

INSTRUCTOR_ID     varchar(50) NULL,

and here is why cf was giving me an error...

because my source data had more than 4 instructors, sql did not know what to do after the 4th instructor and cf errors out. 

So by changing varchar(50) NULL to varchar(100) NULL fixes the problem.

btw... the vendor error code was 8152

Regards,

Art

[Dan_Bracuk]

Or maybe the bracket and semi-colon on line 213.  Are you using tags inside cfscript or something?