I am working with porting an ASP website that connected to an Access Database to MySQL
and am still very new to the Syntax differences.
I've found more than a majority of the site works except one crucial part that submits
the results of a survey into the database and am not sure *exactly* where the problem
lies because I get an error that states
ADODB.Connection.1 error '80004005'
SQLState: 42000
Native Error Code: 1064
[TCX][MyODBC]You have an error in your SQL syntax near '' at line 1
/profile/chemistrymatch/final.asp, line 633
yet line 633 is different depending on what I open the page up with.....When I open
with UltraDev line 633 reads..........con.Execute(sql) with word wrap on
and.......................
'*************************************************************************
' ADD NEW VALUES TO TESTSCORES IN DATABASE
'*************************************************************************
SQL = "INSERT INTO testScores (CUSTOMER_ID, creative, creativeDeveloper, developer,
refiner, maximizer, director, persuader, cooperator, analyst, social, internal,
futurist, realist, feeler, thinker, planner, adapter, values1, values2, values3,
values4, values5, values6, values7, values8, values9, values10, values11, values12,
values13, values14, values15, values16, values17, values18, values19, values20,
motivatedRole1, motivatedRole2, motivatedRole3, MotivatedRole4, motivatedRole5,
impactRole1, impactRole2, impactRole3, impactRole4, tempermentProfile1,
tempermentProfile2, tempermentProfile3, tempermentProfile4, tempermentProfile5,
tempermentProfile6, tempermentProfile7, tempermentProfile8, tempermentProfile9,
tempermentProfile10, tempermentProfile11, tempermentProfile12, tempermentProfile13,
tempermentProfile14, tempermentProfile15, tempermentProfile16, undecidedCount3,
undecidedCount4, undecidedCount5, undecidedCount6, customerName,
CORPORATE_CUSTOMER_ID) SELECT '" & CUSTOMER_ID & "' AS Expr1, '" & creative & "' AS
Expr2, '" & creativeDeveloper & "' AS Expr3, '" & developer & "' AS Expr4, '" &
refiner & "' AS Expr5, '" & maximizer & "' AS Expr6, '" & director & "' AS Expr7, '" &
persuader & "' AS Expr8, '" & cooperator & "' AS Expr9, '" & analyst & "' AS Expr10,
'" & social & "' AS Expr11, '" & internal & "' AS Expr12, '" & futurist & "' AS
Expr13, '" & realist & "' AS Expr14, '" & feeler & "' AS Expr15, '" & thinker & "' AS
Expr16, '" & planner & "' AS Expr17, '" & adapter & "' AS Expr18, '" & v1 & "' AS
Expr19, '" & v2 & "' AS Expr20, '" & v3 & "' AS Expr21, '" & v4 & "' AS Expr22, '" &
v5 & "' AS Expr23, '" & v6 & "' AS Expr24, '" & v7 & "' AS Expr25, '" & v8 & "' AS
Expr26, '" & v9 & "' AS Expr27, '" & v10 & "' AS Expr28, '" & v11 & "' AS Expr29, '" &
v12 & "' AS Expr30, '" & v13 & "' AS Expr31, '" & v14 & "' AS Expr32, '" & v15 & "' AS
Expr33, '" & v16 & "' AS Expr34, '" & v17 & "' AS Expr35, '" & v18 & "' AS Expr36, '"
& v19 & "' AS Expr37, '" & v20 & "' AS Expr38, '" & motivatedRole1 & "' AS Expr39, '"
& motivatedRole2 & "' AS Expr40, '" & motivatedRole3 & "' AS Expr41, '" &
motivatedRole4 & "' AS Expr42, '" & motivatedRole5 & "' AS Expr43, '" & impactStyle1 &
"' AS Expr44, '" & impactStyle2 & "' AS Expr45, '" & impactStyle3 & "' AS Expr46, '" &
impactstyle4 & "' AS Expr47, '" & tempermentProfiles(1) & "' AS Expr48, '" &
tempermentProfiles(2) & "' AS Expr49, '" & tempermentProfiles(3) & "' AS Expr50, '" &
tempermentProfiles(4) & "' AS Expr51, '" & tempermentProfiles(5) & "' AS Expr52, '" &
tempermentProfiles(6) & "' AS Expr53, '" & tempermentProfiles(7) & "' AS Expr54, '" &
tempermentProfiles(8) & "' AS Expr55, '" & tempermentProfiles(9) & "' AS Expr56, '" &
tempermentProfiles(10) & "' AS Expr57, '" & tempermentProfiles(11) & "' AS Expr58, '"
& tempermentProfiles(12) & "' AS Expr59, '" & tempermentProfiles(13) & "' AS Expr60,
'" & tempermentProfiles(14) & "' AS Expr61, '" & tempermentProfiles(15) & "' AS
Expr62, '" & tempermentProfiles(16) & "' AS Expr63, '" & undecidedCount3 & "' AS
Expr64, '" & undecidedCount4 & "' AS Expr65, '" & undecidedCount5 & "' AS Expr66, '" &
undecidedCount6 & "' AS Expr67, '" & customerName & "' AS Expr68, '" &
CORPORATE_CUSTOMER_ID & "' AS Expr69"
with word wrap off....................Can anyone please point me in the correct
direction since this project was forced upon me and now that it is mine I MUST
succeed....It would be very different if I were asked to start from scratch but I am
expected to work with someone elses work and they no longer are around.
Thank You!
Glenn
