error in huge query

[yourkeylady]

Is there something wrong with this huge INSERT statement? I have looked and counted and cannot see it.

INSERT INTO TABLE aaxx61970 (S_PRESSURE_CH_3,S_CHILL_TEMP_F,S_...PRECIPITATION,RECORDTIME) VALUES("0","69.98 °F","N/A","N/A","69.98 °F","N/A","N/A","Wind speed obtained from anemometer Wind speed in knots","48","30.12","0",..."61970","10279","N/A","Height of base of cloud not known or base of clouds at a level lower and tops at a level higher than that of the station","0","0","N/A","0",...,"N/A",
"[URL unfurl="true"]http://weather-weather.com/images/syn//blank.gif","21.1[/URL] °C","N/A","22","N/A","N/A",..."N/A","N/A","N/A","No messurment","N/A","N/A","4","0",..."N/A","2006",
"[URL unfurl="true"]http://weather-weather.com/images/syn/normal.gif","N/A","No[/URL] messurment","N/A","1020.3 hPa","N/A","0","[URL unfurl="true"]http://weather-weather.com/images/syn/[/URL]
yellow.gif","N/A"...,"N/A","[URL unfurl="true"]http://weather-weather.com/[/URL]
images/syn/blank.gif","N/A",..."N/A","21.1 °C","N/A","N/A","[URL unfurl="true"]http://weather-weather.com/images/syn/[/URL]
blank.gif","N/A","Height of base of cloud not known or base of clouds at a level lower and tops at a level higher than that of the station","N/A","N/A","N/A","N/A","N/A","N/A","08-09-2006, 18:48");

Thanks
Tricia

 

[cLFlaVA]

what error are you getting?



*cLFlaVA
----------------------------
[tt]mr. pibb + red vines = crazy delicious![/tt]

[URL unfurl="true"]http://www.coryarthus.com/[/url]

 

[guelphdad]

this is of no use to us if you have shortened it as you aren't showing all the column names:

(S_PRESSURE_CH_3,S_CHILL_TEMP_F,S_...PRECIPITATION,RECORDTIME)

you also can't use ... to skip a field so if you have actually tried to use that in your insert where you are placing the values in then that is what will be creating the error.

 

[r937]

guelphdad, i think maybe yourkeylady didn't code those ellipses

the initial post of this query consisted of a couple of long, long lines, which blew apart the forum software (you couldn't scroll right to see the whole query) so i think the forum moderators edited it

yourkeylady, please repost your query, using a space after every comma

r937.com | rudy.ca

 

[yourkeylady]

It's very strange, I gave up on it and when I came back it worked 100%. I worked so long, and I tried a last minute fix that I thought wouldn't make a difference. I think I took out the primary key when creating the table. But it works fine now. I didn't really need the primary key anyway.

Thanks
Tricia