Ok I have a CF Insert statement (its a long one) and then below the
statement I will paste the error i am getting.
Its appearing that there is a size limit ont he CF Insert statement? Is this
true? All of my inserts except the first
few are just 1 character.
<CFQUERY datasource="#DSN#" name="qputsi">
Insert Into selfinspection
(si_report,
si_dt,
SI_Ops_Coord,
SI_tm,
si_Pavement_Lip_gt_3in,
SI_Hole_gt_5in_diam_3in_deep,
SI_Cracks_Spalling_Bumps,
SI_FOD,
SI_Rubber,
SI_Ponding_Edge_Dams,
SI_Obstruction_Lights,
SI_Cranes_Trees,
SI_Equip_Crew,
SI_Comm_Alarm,
SI_Ruts_Humps_Erosion,
SI_Drainage_Construction,
SI_Objects_Vegetation,
SI_Visible_Standard,
SI_Hold_Lines_Signs,
SI_Frangible_Bases,
SI_Fencing_Gates,
SI_Fencing_Gates_Signs,
SI_Fuel_Labeling,
SI_Fire_Extinguishers,
SI_Grounding_Clips,
SI_Obscured,
SI_Damaged,
SI_Inoperative,
SI_Faulty_Aim,
SI_Rotating_Beacon,
SI_Wind_Indicators,
SI_Barricades_Lights,
SI_Equipment_Parking,
SI_Dead_Birds,
SI_Flocks_of_Bird,
SI_Animals,
SI_Resolved,
SI_dt_Resolved,
SI_Descrip")
Values
('#form.si_report#',
'#form.si_dt#',
'#form.si_Ops_Coord#',
'#form.si_tm#',
'#form.si_Pavement_Lip_gt_3in#',
'#form.si_Hole_gt_5in_diam_3in_deep#',
'#form.si_Cracks_Spalling_Bumps#',
'#form.si_FOD#',
'#form.si_Rubber#',
'#form.si_Ponding_Edge_Dams#',
'#form.si_Obstruction_Lights#',
'#form.si_Cranes_Trees#',
'#form.si_Equip_Crew#',
'#form.si_Comm_Alarm#',
'#form.si_Ruts_Humps_Erosion#',
'#form.si_Drainage_Construction#',
'#form.si_Objects_Vegetation#',
'#form.si_Visible_Standard#',
'#form.si_Hold_Lines_Signs#',
'#form.si_Frangible_Bases#',
'#form.si_Fencing_Gates#',
'#form.si_Fencing_Gates_Signs#',
'#form.si_Fuel_Labeling#',
'#form.si_Fire_Extinguishers#',
'#form.si_Grounding_Clips#',
'#form.si_Obscured#',
'#form.si_Damaged#',
'#form.si_Inoperative#',
'#form.si_Faulty_Aim#',
'#form.si_Rotating_Beacon#',
'#form.si_Wind_Indicators#',
'#form.si_Barricades_Lights#',
'#form.si_Equipment_Parking#',
'#form.si_Dead_Birds#',
'#form.si_Flocks_of_Birds#',
'#form.si_Animals#',
'#form.si_Resolved#',
'#form.si_dt_Resolved#',
'#form.si_Descrip#')
</CFQUERY>
ERROR:
Problem: ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]The identifier that starts
with ') Values ('AM', '{ts '2000-07-14 11:27:12'}', 'KM', '7:00', '', '',
'', '', '', '', '', '', '' is too long. Maximum length is 128.
SQL = "Insert Into selfinspection (si_report, si_dt, SI_Ops_Coord, SI_tm,
si_Pavement_Lip_gt_3in, SI_Hole_gt_5in_diam_3in_deep,
SI_Cracks_Spalling_Bumps, SI_FOD, SI_Rubber, SI_Ponding_Edge_Dams,
SI_Obstruction_Lights, SI_Cranes_Trees, SI_Equip_Crew, SI_Comm_Alarm,
SI_Ruts_Humps_Erosion, SI_Drainage_Construction, SI_Objects_Vegetation,
SI_Visible_Standard, SI_Hold_Lines_Signs, SI_Frangible_Bases,
SI_Fencing_Gates, SI_Fencing_Gates_Signs, SI_Fuel_Labeling,
SI_Fire_Extinguishers, SI_Grounding_Clips, SI_Obscured, SI_Damaged,
SI_Inoperative, SI_Faulty_Aim, SI_Rotating_Beacon, SI_Wind_Indicators,
SI_Barricades_Lights, SI_Equipment_Parking, SI_Dead_Birds,
SI_Flocks_of_Bird, SI_Animals, SI_Resolved, SI_dt_Resolved, SI_Descrip")
Values ('AM', '{ts '2000-07-14 11:27:12'}', 'KM', '7:00', '', '', '', '',
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', '', '', 'This is an AM Test
description.')"
Data Source = "NOTAM"
Any suggestions????
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.