Problem med SQL-sætning

response.write strSQL
response.end
Conn.Execute(strSQL)

og så post sql'en her

Her kommer den:

Update tblMenu set mName_da = 'Ny forening', indhold_da = '<p align="left">N&aring;r I har indtastet jeres data, s&aring; vil vi kontakte jer vedr&oslash;rende igangs&aelig;ttelse af konceptet.</p> <form onsubmit="return FormValAddUnion();" action="/default.asp?mode=addunion" method="post" name="check"> <table width="95%" border="0"> <tbody> <tr> <td width="170"><strong>Foreningens navn:&nbsp;</strong></td> <td><input size="40" name="navn" />&nbsp;<img onmouseover="ddrivetip('Din forenings navn','', 200)" onmouseout="hideddrivetip()" height="18" alt="" width="19" align="absMiddle" border="0" src="/files/96181921/help.gif" /></td> </tr> <tr> <td width="170"><strong>Evt. forkortelse:</strong></td> <td><input size="40" name="navn_kort" />&nbsp;<img onmouseover="ddrivetip('Skriv hvad jeres forening kaldes i daglig tale','', 200)" onmouseout="hideddrivetip()" height="18" alt="" width="19" align="absMiddle" border="0" src="/files/96181921/help.gif" /></td> </tr> <tr> <td width="170"><strong>Adresse:&nbsp;</strong></td> <td><input size="40" name="adresse" />&nbsp;<img onmouseover="ddrivetip('Din forenings adresse','', 200)" onmouseout="hideddrivetip()" height="18" alt="" width="19" align="absMiddle" border="0" src="/files/96181921/help.gif" /></td> </tr> <tr> <td width="170"><strong>Postnr./by:&nbsp;</strong></td> <td><input size="7" name="postnummer" />&nbsp;&nbsp;<input size="22" name="postdistrikt" />&nbsp;<img onmouseover="ddrivetip('Din forenings postnummer og by','', 200)" onmouseout="hideddrivetip()" height="18" alt="" width="19" align="absMiddle" border="0" src="/files/96181921/help.gif" /></td> </tr> <tr> <td width="170"><strong>Land:&nbsp;</strong></td> <td><input size="40" name="land" value="Danmark" />&nbsp;<img onmouseover="ddrivetip('Din forenings land','', 200)" onmouseout="hideddrivetip()" height="18" alt="" width="19" align="absMiddle" border="0" src="/files/96181921/help.gif" /></td> </tr> <tr> <td width="170"><strong>Region:</strong></td> <td><select name="region"> <option value="" selected="selected">V&aelig;lg region</option> <option value="6">Jylland</option> <option value="7">Fyn</option> <option value="8">Sj&aelig;lland og &oslash;er</option> </select>&nbsp;<img onmouseover="ddrivetip('Din forenings region','', 200)" onmouseout="hideddrivetip()" height="18" alt="" width="19" align="absMiddle" border="0" src="/files/96181921/help.gif" /></td> </tr> <tr> <td width="170"><strong>E-mail:&nbsp;</strong></td> <td><input size="40" name="email" />&nbsp;<img onmouseover="ddrivetip('Din forenings e-mail adresse','', 200)" onmouseout="hideddrivetip()" height="18" alt="" width="19" align="absMiddle" border="0" src="/files/96181921/help.gif" /></td> </tr> <tr> <td width="170"><strong>Telefon:&nbsp;</strong></td> <td><input size="40" name="telefon" />&nbsp;<img onmouseover="ddrivetip('Din forenings telefonnr.','', 200)" onmouseout="hideddrivetip()" height="18" alt="" width="19" align="absMiddle" border="0" src="/files/96181921/help.gif" /></td> </tr> <tr> <td width="170"><strong>Telefax:&nbsp;</strong></td> <td><input size="40" name="telefax" />&nbsp;<img onmouseover="ddrivetip('Din forenings telefaxnur.','', 200)" onmouseout="hideddrivetip()" height="18" alt="" width="19" align="absMiddle" border="0" src="/files/96181921/help.gif" /></td> </tr> <tr> <td width="170"><strong>Hjemmeside:&nbsp;</strong></td> <td><input size="40" name="hjemmeside" />&nbsp;<img onmouseover="ddrivetip('Din forenings hjemmeside&lt;br&gt;&lt;br&gt;Eks.: www.forening.dk','', 200)" onmouseout="hideddrivetip()" height="18" alt="" width="19" align="absMiddle" border="0" src="/files/96181921/help.gif" /></td> </tr> <tr> <td valign="top" width="170"><strong>Bankforbindelse:</strong></td> <td><input size="40" name="bank" />&nbsp;<img onmouseover="ddrivetip('Den bank, som I benytter i foreningen. Denne information bruger vil til at overføre penge til jer','', 200)" onmouseout="hideddrivetip()" height="18" alt="" width="19" align="absMiddle" border="0" src="/files/96181921/help.gif" /></td> </tr> <tr> <td valign="top" width="170"><strong>- registreringsnr.:</strong></td> <td><input size="40" name="reg" /></td> </tr> <tr> <td valign="top" width="170"><strong>- kontonr.:</strong></td> <td><input size="40" name="konto" /></td> </tr> <tr> <td valign="top" width="170"><br /> <strong>Kontaktperson:</strong></td> <td><br /> <input size="40" name="kontaktperson_navn" />&nbsp;<img onmouseover="ddrivetip('SupCards kontaktperson i foreningen','', 200)" onmouseout="hideddrivetip()" height="18" alt="" width="19" align="absMiddle" border="0" src="/files/96181921/help.gif" /></td> </tr> <tr> <td valign="top" width="170"><strong>- e-mail:</strong></td> <td><input size="40" name="kontaktperson_email" /></td> </tr> <tr> <td valign="top" width="170"><strong>- telefon:</strong></td> <td><input size="40" name="kontaktperson_telefon" /></td> </tr> <tr> <td valign="top" width="170"><strong>- telefon (i dagtimerne):</strong></td> <td><input size="40" name="kontaktperson_telefon_nemmest" /></td> </tr> <tr> <td valign="top" width="170"><br /> <strong>Beskrivelse:&nbsp;</strong></td> <td><br /> <textarea rows="10" cols="40" name="beskrivelse"></textarea>&nbsp;<img onmouseover="ddrivetip('En beskrivelse af din forening, så brugeren nemt kan genkende foreningen','', 200)" onmouseout="hideddrivetip()" height="18" alt="" width="19" align="absMiddle" border="0" src="/files/96181921/help.gif" /></td> </tr> <tr> <td width="170"><strong>Antal medlemmer:</strong></td> <td><input size="7" name="medlemmer" />&nbsp;<img onmouseover="ddrivetip('Skriv ca. antallet af aktive medlemmer i foreningen','', 200)" onmouseout="hideddrivetip()" height="18" alt="" width="19" align="absMiddle" border="0" src="/files/96181921/help.gif" /></td> </tr> <tr> <td width="170"><br /> <strong>Brugernavn:</strong></td> <td><br /> <input size="40" name="brugernavn" />&nbsp;<img onmouseover="ddrivetip('Dit personlige brugernavn, som skal bruges til at logge ind med','', 200)" onmouseout="hideddrivetip()" height="18" alt="" width="19" align="absMiddle" border="0" src="/files/96181921/help.gif" /></td> </tr> <tr> <td width="170"><strong>Adgangskode:</strong></td> <td><input type="password" size="40" name="adgangskode" />&nbsp;<img onmouseover="ddrivetip('Din personlige adgangskode, som skal bruges til at logge ind med','', 200)" onmouseout="hideddrivetip()" height="18" alt="" width="19" align="absMiddle" border="0" src="/files/96181921/help.gif" /></td> </tr> <tr> <td width="170"><strong>&nbsp;- gentag:</strong></td> <td><input type="password" size="40" name="adgangskode2" />&nbsp;<img onmouseover="ddrivetip('Gentag din personlige adgangskode, så du er sikker på at du har tastet rigtigt','', 200)" onmouseout="hideddrivetip()" height="18" alt="" width="19" align="absMiddle" border="0" src="/files/96181921/help.gif" /></td> </tr> <tr> <td colspan="2"><br /> <input type="checkbox" name="accept" value="on" />&nbsp;Foreningen accepterer <a href="java script:ShowTermsUnion()">vilk&aring;rene</a> for brug af SupCard konceptet</td> </tr> <tr> <td width="170">&nbsp;</td> <td><br /> <input type="submit" value="Tilmeld forening" /></td> </tr> </tbody> </table> </form>', show_da = 1, mName_en = '', indhold_en = '', show_en = 0, mName_de = '', indhold_de = '', show_de = 0, mName_se = '', indhold_se = '', show_se = 0, mName_no = '', indhold_no = '', show_no = 0, mName_it = '', indhold_it = '', show_it = 0, mName_es = '', indhold_es = '', show_es = 0, mName_fr = '', indhold_fr = '', show_fr = 0, parent = 0, img = '', show = 1, klikbar = 1, menu = 1, rettet = #10-11-2006 13:52:53#, user = 1 Where id = 2

du skal ændre alle Request.Form("formfeltnavn") til replace(request.form("formfeltnavn"),"'","''")

Fejlen kommer fordi der er ' i den html du forsøger at gemme i databasen

Takker, det hjalp gevaldigt.