> 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/[email protected]/
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.
