hvor lang SQL

Tro sku ikke der er noget max
Men prøv og sprøg din sql hoster han ved det sikkert :)

Ingen begrænsning!!!!

ok min ser sådan ud men når jeg kører den får jeg fejlen :

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression \'\'\' photopoly= \'\' coatlamplayer= \'\' diglaserimage= \'\' reuseold= \'\' foam60a= \'\' foam40a= \'\' photopolya= \'\' coatlamplayera= \'\' diglaserimagea= \'\' reuseolda= \'\' regslot1= \'\' regslot2= \'\' reglines1= \'\' reglines2= \'\' digsleev1= \'\' digsleev2= \'\' thinsleev1= \'\' thin\'.


men der er ikke en fejl så vidt jeg kan se.

Her er SQLen :ø)

SQL = \"Update sleevs set overskrift= \'\" &  request.form(\"overskrift\") & \"\', \"
SQL = SQL & \"oprettetaf= \'\"& request.form(\"oprettetaf\")&\"\', \"
SQL = SQL & \"kategori= \'\"& request.form(\"kategori\")&\"\', \"
SQL = SQL & \"ordnum= \'\"& request.form(\"ordnum\")&\"\', \"
SQL = SQL & \"custermer= \'\"& request.form(\"custermer\")&\"\', \"
SQL = SQL & \"job= \'\"& request.form(\"job\")&\"\', \"
SQL = SQL & \"aircyl= \'\"& request.form(\"aircyl\")&\"\', \"
SQL = SQL & \"printcir= \'\"& request.form(\"printcir\")&\"\', \"
SQL = SQL & \"sleevlenght= \'\"& request.form(\"sleevlenght\")&\"\', \"
SQL = SQL & \"printingwidht= \'\"& request.form(\"printingwidht\")&\"\', \"
SQL = SQL & \"externalo= \'\"& request.form(\"externalo\")&\"\', \"
SQL = SQL & \"foam60= \'\"& request.form(\"foam60\")&\"\', \"
SQL = SQL & \"foam40= \'\"& request.form(\"foam40\")&\"\' \"
SQL = SQL & \"photopoly= \'\"& request.form(\"photopoly\")&\"\' \"
SQL = SQL & \"coatlamplayer= \'\"& request.form(\"coatlamplayer\")&\"\' \"
SQL = SQL & \"diglaserimage= \'\"& request.form(\"diglaserimage\")&\"\' \"
SQL = SQL & \"reuseold= \'\"& request.form(\"reuseold\")&\"\' \"
SQL = SQL & \"foam60a= \'\"& request.form(\"foam60a\")&\"\' \"
SQL = SQL & \"foam40a= \'\"& request.form(\"foam40a\")&\"\' \"
SQL = SQL & \"photopolya= \'\"& request.form(\"photopolya\")&\"\' \"
SQL = SQL & \"coatlamplayera= \'\"& request.form(\"coatlamplayera\")&\"\' \"
SQL = SQL & \"diglaserimagea= \'\"& request.form(\"diglaserimagea\")&\"\' \"
SQL = SQL & \"reuseolda= \'\"& request.form(\"reuseolda\")&\"\' \"
SQL = SQL & \"regslot1= \'\"& request.form(\"regslot1\")&\"\' \"
SQL = SQL & \"regslot2= \'\"& request.form(\"regslot2\")&\"\' \"
SQL = SQL & \"reglines1= \'\"& request.form(\"reglines1\")&\"\' \"
SQL = SQL & \"reglines2= \'\"& request.form(\"reglines2\")&\"\' \"
SQL = SQL & \"digsleev1= \'\"& request.form(\"digsleev1\")&\"\' \"
SQL = SQL & \"digsleev2= \'\"& request.form(\"digsleev2\")&\"\' \"
SQL = SQL & \"thinsleev1= \'\"& request.form(\"thinsleev1\")&\"\' \"
SQL = SQL & \"thinsleev2= \'\"& request.form(\"thinsleev2\")&\"\' \"
SQL = SQL & \"blanks1= \'\"& request.form(\"blanks1\")&\"\' \"
SQL = SQL & \"blanks2= \'\"& request.form(\"blanks2\")&\"\' \"
SQL = SQL & \"adaptersleev1= \'\"& request.form(\"daptersleev1\")&\"\' \"
SQL = SQL & \"adaptersleev2= \'\"& request.form(\"adaptersleev2\")&\"\' \"
SQL = SQL & \"steelring1= \'\"& request.form(\"steelring1\")&\"\' \"
SQL = SQL & \"steelring2= \'\"& request.form(\"steelring2\")&\"\' \"
SQL = SQL & \"newlamplayer1= \'\"& request.form(\"newlamplayer1\")&\"\' \"
SQL = SQL & \"newlamplayer2= \'\"& request.form(\"newlamplayer2\")&\"\' \"
SQL = SQL & \"mountingsleev1= \'\"& request.form(\"mountingsleev1\")&\"\' \"
SQL = SQL & \"mountingsleev2= \'\"& request.form(\"mountingsleev2\")&\"\' \"
SQL = SQL & \"tape1= \'\"& request.form(\"tape1\")&\"\' \"
SQL = SQL & \"tape2= \'\"& request.form(\"tape2\")&\"\' \"
SQL = SQL & \"transport1= \'\"& request.form(\"transport1\")&\"\' \"
SQL = SQL & \"transport2= \'\"& request.form(\"transport2\")&\"\' \"
SQL = SQL & \"courier1= \'\"& request.form(\"courier1\")&\"\' \"
SQL = SQL & \"courier2= \'\"& request.form(\"courier2\")&\"\' \"
SQL = SQL & \"pris= \'\"& request.form(\"pris\")&\"\' \"
SQL = SQL & \"linkno1a= \'\"& request.form(\"linkno1a\")&\"\' \"
SQL = SQL & \"linkno2a= \'\"& request.form(\"linkno2a\")&\"\' \"
SQL = SQL & \"linkno3a= \'\"& request.form(\"linkno3a\")&\"\' \"
SQL = SQL & \"linkno1b= \'\"& request.form(\"linkno1b\")&\"\' \"
SQL = SQL & \"linkno2b= \'\"& request.form(\"linkno2b\")&\"\' \"
SQL = SQL & \"linkno3b= \'\"& request.form(\"linkno3b\")&\"\' \"
SQL = SQL & \"linkno1c= \'\"& request.form(\"linkno1c\")&\"\' \"
SQL = SQL & \"linkno2c= \'\"& request.form(\"linkno2c\")&\"\' \"
SQL = SQL & \"linkno3c= \'\"& request.form(\"linkno3c\")&\"\' \"
SQL = SQL & \"linkno1d= \'\"& request.form(\"linkno1d\")&\"\' \"
SQL = SQL & \"linkno2d= \'\"& request.form(\"linkno2d\")&\"\' \"
SQL = SQL & \"linkno3d= \'\"& request.form(\"linkno3d\")&\"\' \"
SQL = SQL & \"linkno1e= \'\"& request.form(\"linkno1e\")&\"\' \"
SQL = SQL & \"linkno2e= \'\"& request.form(\"linkno2e\")&\"\' \"
SQL = SQL & \"linkno3e= \'\"& request.form(\"linkno3e\")&\"\' \"
SQL = SQL & \"linkno1f= \'\"& request.form(\"linkno1f\")&\"\' \"
SQL = SQL & \"linkno2f= \'\"& request.form(\"linkno2f\")&\"\' \"
SQL = SQL & \"linkno3f= \'\"& request.form(\"linkno3f\")&\"\' \"
SQL = SQL & \"linkno1g= \'\"& request.form(\"linkno1g\")&\"\' \"
SQL = SQL & \"linkno2g= \'\"& request.form(\"linkno2g\")&\"\' \"
SQL = SQL & \"linkno3g= \'\"& request.form(\"linkno3g\")&\"\' \"
SQL = SQL & \"linkno1h= \'\"& request.form(\"linkno1h\")&\"\' \"
SQL = SQL & \"linkno2h= \'\"& request.form(\"linkno2h\")&\"\' \"
SQL = SQL & \"linkno3h= \'\"& request.form(\"linkno3h\")&\"\' \"
SQL = SQL & \"frontsideprint= \'\"& request.form(\"frontsideprint\")&\"\' \"
SQL = SQL & \"tapethickness= \'\"& request.form(\"tapethickness\")&\"\' \"
SQL = SQL & \"reversedprint= \'\"& request.form(\"reversedprint\")&\"\' \"
SQL = SQL & \"clichethickness= \'\"& request.form(\"clichethickness\")&\"\' \"
SQL = SQL & \"Pris2= \'\"& request.form(\"Pris2\")&\"\' \"
SQL = SQL & \"lenfil= \'\"& request.form(\"lenfil\")&\"\' \"
SQL = SQL & \"grsjob= \'\"& request.form(\"grsjob\")&\"\' \"
SQL = SQL & \"alkmake= \'\"& request.form(\"alkmake\")&\"\' \"
SQL = SQL & \"notat= \'\"& request.form(\"notat\")&\"\' \"
SQL = SQL & \"WHERE ID= \"& request.form(\"linkid\")

Er du så færdig den er lang!!!!!!!!!!!

Hvis du er i tvivl om om det er længden der er problemet, så kan du jo bare dele sql\'en op i flere kald.
Umiddelbart kan jeg ikke se nogen fejl i SQL\'en, men det er svært at sige når den er så lang

Så er der en fejl et eller andet sted, har ikke noget med længden og gøre =)

oki så leder jeg videre :ø)

Takker for point.... Held og lykke med jagten!

en SQL kan være tilnærmet uendelig...det er ingen begrensninger for hvor lang den kan være...

(( du skal bare skrive den korrekt ;-)...noe du ikke har gjort...))