RE: [AspClassicAnyQuestionIsOk] Multiple records deletion

2005-10-27 Thread Dan Powderhill
hid1 is the name of the hidden field you have in your HTML, not the checkbox - shouldn't you be setting the value of Var1 to request.form(delfile)? Also you appear to be missing a closing angle-bracket on your checkbox tag. Dan From:

RE: [AspClassicAnyQuestionIsOk] Multiple records deletion

2005-10-27 Thread Jegatha
sorry, In my code i have the field var1 to request.form(delfile) only, i have mistekenly posted that code, My code is % Var1=request(delfile) SQL=delete from updown where ID IN ('Var1') cn.execute SQL while not rs.eof a=rs(0) % tr form name=frm

[AspClassicAnyQuestionIsOk] Re: Quotation table

2005-10-27 Thread Valter
Hi Dan, sorry I keep bothering you with the same problem. I did try to use your query as it was but it return me the error : Microsoft VBScript compilation (0x800A0409) Unterminated string constant Actually, I did try also to spit it as below, but alltho isn't returning errors the page is

RE: [AspClassicAnyQuestionIsOk] Re: Quotation table

2005-10-27 Thread Dan Powderhill
The SQL query won't cause a VBScript compilation error. It'll be something like a missing - post the line of code which is causing the error? Dan From: AspClassicAnyQuestionIsOk@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Valter Sent: 27 October

Re: [AspClassicAnyQuestionIsOk] Multiple records deletion

2005-10-27 Thread Michael Brinkley
sorry, had a typo. This: Var = replace(Var,,,',) Should be: Var = replace(Var,,,',') If it works for one and not multiple, then you're probably skipping this step. '3' is one value '3,5,7' is one value '3','5','7' is three values Jegatha [EMAIL PROTECTED] wrote: hai,

[AspClassicAnyQuestionIsOk] Re: Quotation table

2005-10-27 Thread Valter
ok this is the line which might cause the error: % set val2 = outpostDB.Execute(SELECT [fondi].[id_fondo], [fondi]. [nome_fondo], (SELECT TOP 1 [valore_quota] FROM [valori] WHERE [id] = [fondi].[id_fondo] ORDER BY [data_quota] DESC) AS [CurrentValue], (SELECT TOP 1 [valore_quota] FROM [valori]