Hmmn
>with ') Values ('AM', '{ts '2000-07-14 11:27:12'}', 'KM', '7:00', '', '',
>'', '', '', '', '', '', '' is too long. Maximum length is 128.
that line looks a bit suspicious. The date you are using has single quotes
twice which i think is causing a syntax error.
The "is to long. maximum length is 128... is a database setting, however
you may want to check out the output.. Something kind of useful is to take
your values and just output them to make sure they will not break and
SQL Queryies Syntax. I think this is what is occuring.
I am very sure ColdFusion does not limit the size of something like that...
I have had insert statements taht spanned a couple hundred lines or more,
It is just a syntax thing which you have to be veyr meticulous about
even one small typing error can make proofing a CF template terrible.
(proofing, validating syntax etc;)
:-)
Jeremy Allen
[EMAIL PROTECTED]
-----Original Message-----
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 14, 2000 11:23 AM
To: '[EMAIL PROTECTED]'
Subject: HELP CF Insert Problem
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.
------------------------------------------------------------------------------
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.
